/*
 Navicat Premium Data Transfer

 Source Server         : pzh
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : 124.223.199.232:3306
 Source Schema         : task_management

 Target Server Type    : MySQL
 Target Server Version : 80027
 File Encoding         : 65001

 Date: 18/05/2022 21:58:22
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for class
-- ----------------------------
DROP TABLE IF EXISTS `class`;
CREATE TABLE `class` (
  `id` int NOT NULL AUTO_INCREMENT,
  `major_id` int NOT NULL COMMENT '外键：专业id',
  `people_num` int NOT NULL COMMENT '班级人数',
  `grade` int NOT NULL COMMENT '年级',
  `class_num` int NOT NULL COMMENT '班级',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `major_id` (`major_id`),
  CONSTRAINT `class_ibfk_1` FOREIGN KEY (`major_id`) REFERENCES `major` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of class
-- ----------------------------
BEGIN;
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (1, 1, 44, 2018, 1, '2022-04-12 15:29:34', '2022-04-12 15:30:54', 0);
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (2, 1, 42, 2018, 2, '2022-04-12 15:31:19', NULL, 0);
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (3, 1, 43, 2018, 3, '2022-04-12 15:31:41', NULL, 0);
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (4, 1, 44, 2018, 4, '2022-04-17 09:35:04', NULL, 0);
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (5, 2, 38, 2019, 1, '2022-04-23 15:10:36', NULL, 0);
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (6, 2, 36, 2019, 2, '2022-04-23 15:10:49', NULL, 0);
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (7, 2, 40, 2019, 3, '2022-04-23 15:11:04', NULL, 0);
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (8, 4, 35, 2018, 1, '2022-05-15 15:20:49', NULL, 0);
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (9, 4, 37, 2018, 2, '2022-05-15 15:21:06', NULL, 0);
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (10, 1, 50, 2019, 1, '2022-05-18 00:07:03', NULL, 0);
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (11, 1, 34, 2020, 1, '2022-05-18 00:25:02', NULL, 0);
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (12, 1, 35, 2020, 2, '2022-05-18 00:25:38', NULL, 0);
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (13, 1, 36, 2020, 3, '2022-05-18 00:25:57', NULL, 0);
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (14, 1, 45, 2021, 1, '2022-05-18 00:28:19', NULL, 0);
INSERT INTO `class` (`id`, `major_id`, `people_num`, `grade`, `class_num`, `create_time`, `update_time`, `deleted`) VALUES (15, 1, 45, 2021, 2, '2022-05-18 00:28:33', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for college
-- ----------------------------
DROP TABLE IF EXISTS `college`;
CREATE TABLE `college` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '二级学院名',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of college
-- ----------------------------
BEGIN;
INSERT INTO `college` (`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (1, '数学与计算机学院', '2022-04-11 16:24:19', '2022-04-11 16:24:34', 0);
INSERT INTO `college` (`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (2, '外国语学院', '2022-04-12 09:13:28', NULL, 0);
INSERT INTO `college` (`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (3, '人文社科学院', '2022-05-07 01:00:45', NULL, 0);
INSERT INTO `college` (`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (4, '智能制造学院', '2022-05-07 01:01:43', NULL, 0);
INSERT INTO `college` (`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (5, '艺术学院', '2022-05-07 01:01:54', NULL, 0);
INSERT INTO `college` (`id`, `name`, `create_time`, `update_time`, `deleted`) VALUES (6, '法学院', '2022-05-14 15:44:15', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '课程名',
  `code` varchar(32) DEFAULT NULL COMMENT '课程代码',
  `type_id` int NOT NULL COMMENT '外键：课程类别',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `type_id` (`type_id`),
  CONSTRAINT `course_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `course_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of course
-- ----------------------------
BEGIN;
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (1, '测试课程1', 'test01', 2, '2022-04-13 09:39:39', '2022-05-07 01:41:02', 1);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (2, '面向对象程序设计', '201900229', 3, '2022-04-17 09:45:42', '2022-05-18 08:34:33', 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (3, '程序设计基础', '201900124', 3, '2022-04-17 09:46:16', '2022-05-18 08:32:42', 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (4, '大学英语1', '201901239', 5, '2022-05-07 01:41:36', '2022-05-16 10:58:45', 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (5, '《职业生涯规划》(一)', '201900016', 4, '2022-05-16 10:47:57', NULL, 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (6, '面向对象程序设计实验', '201900126', 3, '2022-05-16 10:54:07', '2022-05-18 08:35:04', 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (7, '高等数学(理工)B1', '201904295', 10, '2022-05-16 10:55:44', NULL, 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (8, '高等数学(理工)B2', '201904297', 10, '2022-05-16 10:56:55', NULL, 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (9, '大学英语2', '201901243', 5, '2022-05-16 10:59:25', NULL, 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (10, '大学英语3', '201901247', 5, '2022-05-16 10:59:53', NULL, 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (11, '大学物理1', '201901216', 10, '2022-05-16 12:11:18', NULL, 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (12, '大学物理2', '201901223', 10, '2022-05-16 12:11:48', NULL, 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (13, '大学物理实验', '201901229', 12, '2022-05-16 12:12:20', '2022-05-16 20:58:07', 1);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (14, '面向对象需求分析与建模', '201907323', 3, '2022-05-18 08:34:13', NULL, 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (15, 'Web前端开发技术', '201900351', 3, '2022-05-18 08:36:07', NULL, 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (16, 'JAVA WEB应用开发实训', '201900224', 13, '2022-05-18 08:36:43', NULL, 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (17, '软件工程及项目管理', '202000224', 3, '2022-05-18 08:37:45', NULL, 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (18, '毕业实习', '201900502', 16, '2022-05-18 08:39:21', '2022-05-18 08:47:45', 0);
INSERT INTO `course` (`id`, `name`, `code`, `type_id`, `create_time`, `update_time`, `deleted`) VALUES (19, '毕业论文', '201900483', 17, '2022-05-18 08:40:06', '2022-05-18 08:47:39', 0);
COMMIT;

-- ----------------------------
-- Table structure for course_type
-- ----------------------------
DROP TABLE IF EXISTS `course_type`;
CREATE TABLE `course_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '课程类别名',
  `standard_num` int DEFAULT NULL COMMENT '标准班人数',
  `max_num` int DEFAULT NULL COMMENT '人数上限',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of course_type
-- ----------------------------
BEGIN;
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (1, 'test', 32, 40, '2022-04-13 09:21:12', '2022-05-07 01:32:50', 1);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (2, 'test2', 30, 40, '2022-04-13 09:23:10', '2022-05-07 01:32:47', 1);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (3, '学科基础、专业课（不含艺术学院）', 60, 80, '2022-04-17 09:44:00', '2022-05-16 10:35:39', 0);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (4, '通识选修', 120, 180, '2022-04-17 09:44:29', '2022-05-16 10:22:56', 0);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (5, '公共外语', 60, 80, '2022-05-07 01:34:13', NULL, 0);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (6, '思想政治理论课', 120, 180, '2022-05-07 01:34:38', NULL, 0);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (7, '体育', 50, 70, '2022-05-16 10:20:21', '2022-05-16 10:33:55', 1);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (8, '体育、计算机基础1', 50, 70, '2022-05-16 10:21:17', '2022-05-16 10:34:19', 0);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (9, '学科基础', 60, 80, '2022-05-16 10:25:58', '2022-05-16 10:34:41', 1);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (10, '工数、高数、普物、电工学、制图、计算机基础2', 90, 120, '2022-05-16 10:32:51', NULL, 0);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (11, '艺术专业课程（理论课）', 40, 50, '2022-05-16 10:36:06', NULL, 0);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (12, '公共实验课（大学物理实验、金工实习）', 50, 60, '2022-05-16 10:36:26', NULL, 0);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (13, '专业实验课', 40, 50, '2022-05-16 10:36:58', NULL, 0);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (14, '实习、实训（不含毕业实习）', 45, 999, '2022-05-18 08:43:55', NULL, 0);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (15, '医学专业毕业实习', 160, 999, '2022-05-18 08:44:27', NULL, 0);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (16, '非医学专业毕业实习', 80, 999, '2022-05-18 08:44:42', NULL, 0);
INSERT INTO `course_type` (`id`, `name`, `standard_num`, `max_num`, `create_time`, `update_time`, `deleted`) VALUES (17, '毕业设计（论文）、课程设计', 30, 999, '2022-05-18 08:45:06', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for grade
-- ----------------------------
DROP TABLE IF EXISTS `grade`;
CREATE TABLE `grade` (
  `id` int NOT NULL AUTO_INCREMENT,
  `grade` int NOT NULL COMMENT '年级',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of grade
-- ----------------------------
BEGIN;
INSERT INTO `grade` (`id`, `grade`, `create_time`, `update_time`, `deleted`) VALUES (1, 2018, '2022-04-12 11:30:13', '2022-04-12 11:30:32', 0);
INSERT INTO `grade` (`id`, `grade`, `create_time`, `update_time`, `deleted`) VALUES (2, 2019, '2022-04-12 11:31:13', NULL, 0);
INSERT INTO `grade` (`id`, `grade`, `create_time`, `update_time`, `deleted`) VALUES (3, 2020, '2022-04-17 09:35:28', NULL, 0);
INSERT INTO `grade` (`id`, `grade`, `create_time`, `update_time`, `deleted`) VALUES (4, 2021, '2022-05-07 01:28:50', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for groups
-- ----------------------------
DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '教研室名字',
  `college_id` int NOT NULL COMMENT '外键：二级学院id',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `college_id` (`college_id`),
  CONSTRAINT `groups_ibfk_1` FOREIGN KEY (`college_id`) REFERENCES `college` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of groups
-- ----------------------------
BEGIN;
INSERT INTO `groups` (`id`, `name`, `college_id`, `create_time`, `update_time`, `deleted`) VALUES (1, '计算机基础教研室', 1, '2022-04-01 12:05:59', '2022-05-16 20:41:49', 0);
INSERT INTO `groups` (`id`, `name`, `college_id`, `create_time`, `update_time`, `deleted`) VALUES (2, '测试教研室', 1, '2022-04-11 15:46:20', '2022-04-11 15:46:28', 1);
INSERT INTO `groups` (`id`, `name`, `college_id`, `create_time`, `update_time`, `deleted`) VALUES (3, '软件工程教研室', 1, '2022-04-11 15:46:45', '2022-04-21 01:33:18', 0);
INSERT INTO `groups` (`id`, `name`, `college_id`, `create_time`, `update_time`, `deleted`) VALUES (4, '网络工程教研室', 1, '2022-04-12 09:14:20', '2022-05-16 20:41:36', 0);
INSERT INTO `groups` (`id`, `name`, `college_id`, `create_time`, `update_time`, `deleted`) VALUES (5, '英语教研室', 2, '2022-05-07 01:17:49', NULL, 0);
INSERT INTO `groups` (`id`, `name`, `college_id`, `create_time`, `update_time`, `deleted`) VALUES (6, '翻译教研室', 2, '2022-05-07 01:18:02', NULL, 0);
INSERT INTO `groups` (`id`, `name`, `college_id`, `create_time`, `update_time`, `deleted`) VALUES (7, '法学教研室', 6, '2022-05-14 15:45:59', NULL, 0);
INSERT INTO `groups` (`id`, `name`, `college_id`, `create_time`, `update_time`, `deleted`) VALUES (8, '公共数学教研室', 1, '2022-05-16 20:42:35', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for major
-- ----------------------------
DROP TABLE IF EXISTS `major`;
CREATE TABLE `major` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '专业名',
  `college_id` int NOT NULL COMMENT '外键：学院id',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `college_id` (`college_id`),
  CONSTRAINT `major_ibfk_1` FOREIGN KEY (`college_id`) REFERENCES `college` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of major
-- ----------------------------
BEGIN;
INSERT INTO `major` (`id`, `name`, `college_id`, `create_time`, `update_time`, `deleted`) VALUES (1, '软件工程', 1, '2022-04-11 16:53:30', NULL, 0);
INSERT INTO `major` (`id`, `name`, `college_id`, `create_time`, `update_time`, `deleted`) VALUES (2, '计算机科学与技术', 1, '2022-04-11 17:42:34', NULL, 0);
INSERT INTO `major` (`id`, `name`, `college_id`, `create_time`, `update_time`, `deleted`) VALUES (3, '网络工程', 1, '2022-04-17 09:33:17', NULL, 0);
INSERT INTO `major` (`id`, `name`, `college_id`, `create_time`, `update_time`, `deleted`) VALUES (4, '英语', 2, '2022-05-07 01:03:30', NULL, 0);
INSERT INTO `major` (`id`, `name`, `college_id`, `create_time`, `update_time`, `deleted`) VALUES (5, '翻译', 2, '2022-05-07 01:03:41', NULL, 0);
INSERT INTO `major` (`id`, `name`, `college_id`, `create_time`, `update_time`, `deleted`) VALUES (6, '法学', 6, '2022-05-14 15:45:16', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL COMMENT '菜单名字',
  `icon` varchar(64) DEFAULT NULL COMMENT '图标',
  `path` varchar(64) DEFAULT NULL COMMENT '路径',
  `is_show` int DEFAULT NULL COMMENT '是否显示',
  `pid` int DEFAULT NULL COMMENT '父菜单id',
  `router` varchar(64) DEFAULT NULL COMMENT '路由名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (1, '控制台', 'dashboard', 'dashboard', 1, 0, 'dashboard');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (2, '工作台', NULL, 'workplace', 1, 1, 'workplace');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (3, '分析页', '', 'analysis', 1, 1, 'analysis');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (4, '组织结构', 'apartment', 'organization', 1, 0, 'organization');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (5, '学院管理', NULL, 'college', 1, 4, 'college');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (6, '专业管理', NULL, 'major', 1, 4, 'major');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (7, '班级管理', NULL, 'classes', 1, 4, 'classes');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (8, '年级管理', NULL, 'grade', 1, 4, 'grade');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (9, '学期管理', NULL, 'semester', 1, 4, 'semester');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (10, '课程结构', 'container', 'courses', 1, 0, 'courses');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (11, '课程管理', NULL, 'course', 1, 10, 'course');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (12, '课程类别', NULL, 'type', 1, 10, 'type');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (13, '人员结构', 'usergroup-add', 'personnel', 1, 0, 'personnel');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (14, '人员管理', NULL, 'user', 1, 13, 'user');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (15, '角色管理', NULL, 'role', 1, 13, 'role');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (16, '菜单绑定', NULL, 'menus', 1, 13, 'menus');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (17, '教研室', NULL, 'group', 1, 4, 'group');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (18, '任务分配', 'schedule', 'task_allocation', 1, 0, 'task_allocation');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (19, '培养方案', NULL, 'program', 1, 18, 'program');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (20, '教学计划', NULL, 'plan', 1, 18, 'plan');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (21, '教学任务与工作量', NULL, 'task', 1, 18, 'task');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (22, '教学任务', NULL, 'workload', 1, 18, 'workload');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (23, '工作量统计图', NULL, 'statistics', 1, 18, 'statistics');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (24, '历史记录', 'history', 'history', 1, 0, 'history');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (25, '教学任务记录', '', 'task_final', 1, 24, 'task_final');
INSERT INTO `menu` (`id`, `name`, `icon`, `path`, `is_show`, `pid`, `router`) VALUES (26, '工作量统计图', NULL, 'workload_final', 1, 24, 'workload_final');
COMMIT;

-- ----------------------------
-- Table structure for plan
-- ----------------------------
DROP TABLE IF EXISTS `plan`;
CREATE TABLE `plan` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '教学计划id',
  `program_id` int DEFAULT NULL COMMENT '外键：培养方案id',
  `semester_id` int DEFAULT NULL COMMENT '外键：学期id',
  `total_num` int DEFAULT NULL COMMENT '教学总人数',
  `remain_num` int DEFAULT NULL COMMENT '剩余人数',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `program_id` (`program_id`),
  KEY `semester_id` (`semester_id`),
  CONSTRAINT `plan_ibfk_1` FOREIGN KEY (`program_id`) REFERENCES `program` (`id`),
  CONSTRAINT `plan_ibfk_2` FOREIGN KEY (`semester_id`) REFERENCES `semester` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of plan
-- ----------------------------
BEGIN;
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (8, 10, 1, 173, 0, '2022-05-18 09:37:35', '2022-05-18 18:44:59', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (9, 11, 2, 173, 0, '2022-05-18 09:39:21', '2022-05-18 18:37:34', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (10, 12, 3, 173, 0, '2022-05-18 09:51:05', '2022-05-18 18:38:13', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (11, 13, 4, 173, 0, '2022-05-18 10:16:54', '2022-05-18 18:39:47', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (12, 14, 5, 173, 0, '2022-05-18 10:18:03', '2022-05-18 18:40:38', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (13, 15, 6, 173, 0, '2022-05-18 10:19:30', '2022-05-18 18:41:43', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (14, 16, 7, 173, 0, '2022-05-18 10:20:54', '2022-05-18 18:43:28', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (16, 18, 8, 173, 48, '2022-05-18 12:30:32', '2022-05-18 19:47:21', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (20, 22, 10, 50, 50, '2022-05-18 16:17:23', '2022-05-18 17:34:07', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (21, 23, 9, 50, 50, '2022-05-18 16:17:23', '2022-05-18 17:34:07', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (22, 24, 8, 50, 0, '2022-05-18 16:17:24', '2022-05-18 19:47:58', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (23, 25, 7, 50, 0, '2022-05-18 16:17:24', '2022-05-18 19:00:11', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (24, 26, 6, 50, 0, '2022-05-18 16:17:24', '2022-05-18 18:59:53', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (25, 27, 5, 50, 0, '2022-05-18 16:17:25', '2022-05-18 18:59:15', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (26, 28, 4, 50, 0, '2022-05-18 16:17:25', '2022-05-18 18:58:09', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (27, 29, 3, 50, 0, '2022-05-18 16:17:26', '2022-05-18 18:56:25', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (28, 30, 7, 105, 0, '2022-05-18 16:23:06', '2022-05-18 19:06:12', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (29, 31, 6, 105, 0, '2022-05-18 16:23:07', '2022-05-18 19:04:41', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (30, 32, 5, 105, 0, '2022-05-18 16:23:07', '2022-05-18 19:03:39', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (31, 33, 9, 105, 105, '2022-05-18 16:23:08', '2022-05-18 17:34:07', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (32, 34, 8, 105, 50, '2022-05-18 16:23:08', '2022-05-18 19:48:34', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (33, 35, 13, 105, 105, '2022-05-18 16:23:08', '2022-05-18 17:34:07', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (34, 36, 11, 105, 105, '2022-05-18 16:23:09', '2022-05-18 17:34:07', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (35, 37, 10, 105, 105, '2022-05-18 16:23:09', '2022-05-18 17:34:07', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (36, 38, 13, 90, 90, '2022-05-18 16:23:19', '2022-05-18 17:34:07', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (37, 39, 10, 90, 90, '2022-05-18 16:23:19', '2022-05-18 17:34:07', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (38, 40, 12, 90, 90, '2022-05-18 16:23:20', '2022-05-18 17:34:07', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (39, 41, 14, 90, 90, '2022-05-18 16:23:20', '2022-05-18 17:34:07', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (40, 42, 8, 90, 0, '2022-05-18 16:23:21', '2022-05-18 19:49:19', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (41, 43, 7, 90, 0, '2022-05-18 16:23:21', '2022-05-18 19:24:17', 1);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (42, 44, 11, 90, 90, '2022-05-18 16:23:21', '2022-05-18 17:34:07', 0);
INSERT INTO `plan` (`id`, `program_id`, `semester_id`, `total_num`, `remain_num`, `create_time`, `update_time`, `deleted`) VALUES (43, 45, 9, 90, 90, '2022-05-18 16:23:22', '2022-05-18 17:34:07', 0);
COMMIT;

-- ----------------------------
-- Table structure for program
-- ----------------------------
DROP TABLE IF EXISTS `program`;
CREATE TABLE `program` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '培养方案id',
  `course_id` int DEFAULT NULL COMMENT '外键：课程id',
  `grade_id` int DEFAULT NULL COMMENT '外键：年级id',
  `major_id` int DEFAULT NULL COMMENT '外键：专业id',
  `experimental` float(11,2) DEFAULT NULL COMMENT '实验学时',
  `theoretical` float(11,2) DEFAULT NULL COMMENT '理论学时',
  `credit` float(11,2) DEFAULT NULL COMMENT '学分',
  `status` int DEFAULT NULL COMMENT '是否完成分配： 0 否。1 是',
  `method` int DEFAULT NULL COMMENT '考核方式：0 考察  1 考试',
  `term` int DEFAULT NULL COMMENT '课程所对应的学期（1-8）',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  KEY `grade_id` (`grade_id`),
  KEY `major_id` (`major_id`),
  CONSTRAINT `program_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `program_ibfk_2` FOREIGN KEY (`grade_id`) REFERENCES `grade` (`id`),
  CONSTRAINT `program_ibfk_3` FOREIGN KEY (`major_id`) REFERENCES `major` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of program
-- ----------------------------
BEGIN;
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (10, 3, 1, 1, 0.00, 56.00, 3.50, 1, 1, 1, '2022-05-18 09:37:35', '2022-05-18 18:36:25', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (11, 2, 1, 1, 0.00, 56.00, 3.50, 1, 1, 2, '2022-05-18 09:39:20', '2022-05-18 18:37:34', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (12, 14, 1, 1, 0.00, 32.00, 2.00, 1, 1, 3, '2022-05-18 09:51:05', '2022-05-18 18:38:13', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (13, 15, 1, 1, 0.00, 40.00, 2.50, 1, 1, 4, '2022-05-18 10:16:53', '2022-05-18 18:39:47', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (14, 16, 1, 1, 56.00, 0.00, 3.50, 1, 1, 5, '2022-05-18 10:18:03', '2022-05-18 18:40:39', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (15, 17, 1, 1, 0.00, 32.00, 2.00, 1, 1, 6, '2022-05-18 10:19:30', '2022-05-18 18:41:43', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (16, 18, 1, 1, 0.00, 0.00, 2.00, 1, 0, 7, '2022-05-18 10:20:54', '2022-05-18 18:43:28', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (18, 19, 1, 1, 0.00, 0.00, 14.00, 0, 0, 8, '2022-05-18 12:30:32', '2022-05-18 12:31:39', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (22, 19, 2, 1, 0.00, 0.00, 14.00, 0, 0, 8, '2022-05-18 16:17:23', '2022-05-18 12:31:39', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (23, 18, 2, 1, 0.00, 0.00, 2.00, 0, 0, 7, '2022-05-18 16:17:23', NULL, 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (24, 17, 2, 1, 0.00, 32.00, 2.00, 1, 1, 6, '2022-05-18 16:17:23', '2022-05-18 19:47:58', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (25, 16, 2, 1, 56.00, 0.00, 3.50, 1, 1, 5, '2022-05-18 16:17:24', '2022-05-18 19:00:12', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (26, 15, 2, 1, 0.00, 40.00, 2.50, 1, 1, 4, '2022-05-18 16:17:24', '2022-05-18 18:59:53', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (27, 14, 2, 1, 0.00, 32.00, 2.00, 1, 1, 3, '2022-05-18 16:17:25', '2022-05-18 18:59:15', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (28, 2, 2, 1, 0.00, 56.00, 3.50, 1, 1, 2, '2022-05-18 16:17:25', '2022-05-18 18:58:09', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (29, 3, 2, 1, 0.00, 56.00, 3.50, 1, 1, 1, '2022-05-18 16:17:25', '2022-05-18 18:56:26', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (30, 14, 3, 1, 0.00, 32.00, 2.00, 1, 1, 3, '2022-05-18 16:23:06', '2022-05-18 19:06:12', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (31, 2, 3, 1, 0.00, 56.00, 3.50, 1, 1, 2, '2022-05-18 16:23:07', '2022-05-18 19:04:41', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (32, 3, 3, 1, 0.00, 56.00, 3.50, 1, 1, 1, '2022-05-18 16:23:07', '2022-05-18 19:03:39', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (33, 16, 3, 1, 56.00, 0.00, 3.50, 0, 1, 5, '2022-05-18 16:23:07', NULL, 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (34, 15, 3, 1, 0.00, 40.00, 2.50, 0, 1, 4, '2022-05-18 16:23:08', NULL, 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (35, 19, 3, 1, 0.00, 0.00, 14.00, 0, 0, 8, '2022-05-18 16:23:08', '2022-05-18 12:31:39', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (36, 18, 3, 1, 0.00, 0.00, 2.00, 0, 0, 7, '2022-05-18 16:23:08', NULL, 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (37, 17, 3, 1, 0.00, 32.00, 2.00, 0, 1, 6, '2022-05-18 16:23:09', NULL, 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (38, 17, 4, 1, 0.00, 32.00, 2.00, 0, 1, 6, '2022-05-18 16:23:19', NULL, 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (39, 15, 4, 1, 0.00, 40.00, 2.50, 0, 1, 4, '2022-05-18 16:23:19', NULL, 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (40, 19, 4, 1, 0.00, 0.00, 14.00, 0, 0, 8, '2022-05-18 16:23:19', '2022-05-18 12:31:39', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (41, 18, 4, 1, 0.00, 0.00, 2.00, 0, 0, 7, '2022-05-18 16:23:20', NULL, 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (42, 2, 4, 1, 0.00, 56.00, 3.50, 1, 1, 2, '2022-05-18 16:23:20', '2022-05-18 19:49:19', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (43, 3, 4, 1, 0.00, 56.00, 3.50, 1, 1, 1, '2022-05-18 16:23:21', '2022-05-18 19:24:17', 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (44, 16, 4, 1, 56.00, 0.00, 3.50, 0, 1, 5, '2022-05-18 16:23:21', NULL, 0);
INSERT INTO `program` (`id`, `course_id`, `grade_id`, `major_id`, `experimental`, `theoretical`, `credit`, `status`, `method`, `term`, `create_time`, `update_time`, `deleted`) VALUES (45, 14, 4, 1, 0.00, 32.00, 2.00, 0, 1, 3, '2022-05-18 16:23:22', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `alias` varchar(64) NOT NULL COMMENT '别名',
  `weight` int NOT NULL COMMENT '角色权重',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` (`id`, `name`, `alias`, `weight`, `create_time`, `update_time`, `deleted`) VALUES (1, 'sys_admin', '系统管理员', 1, '2022-04-01 00:43:15', '2022-05-15 11:31:20', 0);
INSERT INTO `role` (`id`, `name`, `alias`, `weight`, `create_time`, `update_time`, `deleted`) VALUES (2, 'org_admin', '学院领导', 3, '2022-04-09 07:42:45', '2022-05-17 23:53:38', 0);
INSERT INTO `role` (`id`, `name`, `alias`, `weight`, `create_time`, `update_time`, `deleted`) VALUES (3, 'admin', '教研室主任', 4, '2022-04-10 10:11:22', '2022-05-15 11:31:33', 0);
INSERT INTO `role` (`id`, `name`, `alias`, `weight`, `create_time`, `update_time`, `deleted`) VALUES (4, 'teacher', '普通教师', 5, '2022-04-09 15:56:14', '2022-05-18 16:41:46', 0);
INSERT INTO `role` (`id`, `name`, `alias`, `weight`, `create_time`, `update_time`, `deleted`) VALUES (6, 'test', '测试', 0, '2022-04-10 10:46:46', '2022-04-20 15:06:40', 1);
INSERT INTO `role` (`id`, `name`, `alias`, `weight`, `create_time`, `update_time`, `deleted`) VALUES (7, 'super_admin', '校级领导', 2, '2022-05-15 09:58:01', '2022-05-15 11:31:07', 0);
COMMIT;

-- ----------------------------
-- Table structure for role_menu
-- ----------------------------
DROP TABLE IF EXISTS `role_menu`;
CREATE TABLE `role_menu` (
  `id` int NOT NULL AUTO_INCREMENT,
  `m_id` int DEFAULT NULL COMMENT '外键：菜单id',
  `r_id` int DEFAULT NULL COMMENT '外键：角色id',
  PRIMARY KEY (`id`),
  KEY `m_id` (`m_id`),
  KEY `r_id` (`r_id`),
  CONSTRAINT `role_menu_ibfk_1` FOREIGN KEY (`m_id`) REFERENCES `menu` (`id`),
  CONSTRAINT `role_menu_ibfk_2` FOREIGN KEY (`r_id`) REFERENCES `role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of role_menu
-- ----------------------------
BEGIN;
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (1, 1, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (4, 4, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (5, 5, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (6, 6, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (7, 7, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (8, 8, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (9, 9, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (10, 10, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (11, 11, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (12, 12, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (13, 13, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (14, 14, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (15, 15, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (16, 16, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (17, 17, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (18, 18, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (19, 19, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (20, 20, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (21, 21, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (23, 23, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (24, 24, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (25, 25, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (26, 26, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (28, 1, 2);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (29, 2, 2);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (31, 4, 2);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (33, 6, 2);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (34, 17, 2);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (35, 13, 2);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (36, 14, 2);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (37, 24, 2);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (38, 25, 2);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (39, 26, 2);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (40, 1, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (41, 2, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (43, 4, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (44, 7, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (45, 8, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (46, 9, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (47, 10, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (48, 11, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (49, 12, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (50, 18, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (51, 19, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (52, 20, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (53, 21, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (55, 23, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (56, 24, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (57, 25, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (58, 26, 3);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (59, 1, 4);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (60, 2, 4);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (62, 18, 4);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (64, 23, 4);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (65, 24, 4);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (66, 25, 4);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (67, 26, 4);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (68, 22, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (70, 22, 4);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (71, 2, 1);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (72, 1, 7);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (73, 2, 7);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (74, 4, 7);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (75, 5, 7);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (77, 13, 7);
INSERT INTO `role_menu` (`id`, `m_id`, `r_id`) VALUES (78, 14, 7);
COMMIT;

-- ----------------------------
-- Table structure for semester
-- ----------------------------
DROP TABLE IF EXISTS `semester`;
CREATE TABLE `semester` (
  `id` int NOT NULL AUTO_INCREMENT,
  `year` int NOT NULL COMMENT '学年',
  `number` int NOT NULL COMMENT '1: 上 2: 下',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of semester
-- ----------------------------
BEGIN;
INSERT INTO `semester` (`id`, `year`, `number`, `create_time`, `update_time`, `deleted`) VALUES (1, 2018, 1, '2022-04-12 14:12:24', NULL, 0);
INSERT INTO `semester` (`id`, `year`, `number`, `create_time`, `update_time`, `deleted`) VALUES (2, 2018, 2, '2022-04-12 14:13:48', NULL, 0);
INSERT INTO `semester` (`id`, `year`, `number`, `create_time`, `update_time`, `deleted`) VALUES (3, 2019, 1, '2022-04-17 09:38:09', NULL, 0);
INSERT INTO `semester` (`id`, `year`, `number`, `create_time`, `update_time`, `deleted`) VALUES (4, 2019, 2, '2022-04-17 09:39:52', NULL, 0);
INSERT INTO `semester` (`id`, `year`, `number`, `create_time`, `update_time`, `deleted`) VALUES (5, 2020, 1, '2022-04-17 09:40:01', NULL, 0);
INSERT INTO `semester` (`id`, `year`, `number`, `create_time`, `update_time`, `deleted`) VALUES (6, 2020, 2, '2022-04-17 09:40:09', NULL, 0);
INSERT INTO `semester` (`id`, `year`, `number`, `create_time`, `update_time`, `deleted`) VALUES (7, 2021, 1, '2022-04-17 09:41:56', NULL, 0);
INSERT INTO `semester` (`id`, `year`, `number`, `create_time`, `update_time`, `deleted`) VALUES (8, 2021, 2, '2022-04-17 09:42:06', NULL, 0);
INSERT INTO `semester` (`id`, `year`, `number`, `create_time`, `update_time`, `deleted`) VALUES (9, 2022, 1, '2022-04-17 09:42:27', NULL, 0);
INSERT INTO `semester` (`id`, `year`, `number`, `create_time`, `update_time`, `deleted`) VALUES (10, 2022, 2, '2022-04-17 09:42:37', NULL, 0);
INSERT INTO `semester` (`id`, `year`, `number`, `create_time`, `update_time`, `deleted`) VALUES (11, 2023, 1, '2022-04-17 17:15:35', NULL, 0);
INSERT INTO `semester` (`id`, `year`, `number`, `create_time`, `update_time`, `deleted`) VALUES (12, 2024, 2, '2022-05-18 13:02:45', NULL, 0);
INSERT INTO `semester` (`id`, `year`, `number`, `create_time`, `update_time`, `deleted`) VALUES (13, 2023, 2, '2022-05-18 14:43:50', NULL, 0);
INSERT INTO `semester` (`id`, `year`, `number`, `create_time`, `update_time`, `deleted`) VALUES (14, 2024, 1, '2022-05-18 16:23:20', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for task
-- ----------------------------
DROP TABLE IF EXISTS `task`;
CREATE TABLE `task` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '教学任务id',
  `teacher_id` int DEFAULT NULL COMMENT '外键：教师用户id',
  `plan_id` int DEFAULT NULL COMMENT '外键：教学计划id',
  `merge` int DEFAULT NULL COMMENT '是否合班：0 否，1 是',
  `actual_num` int DEFAULT NULL COMMENT '教学班实际人数',
  `max_num` int DEFAULT NULL COMMENT '最大人数',
  `common_num` int DEFAULT NULL COMMENT '标准人数',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `teacher_id` (`teacher_id`),
  KEY `plan_id` (`plan_id`),
  CONSTRAINT `task_ibfk_1` FOREIGN KEY (`teacher_id`) REFERENCES `user` (`id`),
  CONSTRAINT `task_ibfk_2` FOREIGN KEY (`plan_id`) REFERENCES `plan` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of task
-- ----------------------------
BEGIN;
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (52, 13, 8, 1, 60, 80, 60, '2022-05-18 18:35:56', '2022-05-18 18:52:51', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (53, 13, 8, 1, 60, 80, 60, '2022-05-18 18:36:06', '2022-05-18 18:52:51', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (54, 13, 8, 1, 53, 80, 60, '2022-05-18 18:36:25', '2022-05-18 18:52:52', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (55, 5, 9, 1, 60, 80, 60, '2022-05-18 18:37:08', '2022-05-18 18:52:52', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (56, 5, 9, 1, 60, 80, 60, '2022-05-18 18:37:23', '2022-05-18 18:52:53', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (57, 5, 9, 1, 53, 80, 60, '2022-05-18 18:37:34', '2022-05-18 18:52:54', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (58, 10, 10, 1, 60, 80, 60, '2022-05-18 18:37:48', '2022-05-18 18:52:54', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (59, 10, 10, 1, 60, 80, 60, '2022-05-18 18:38:03', '2022-05-18 18:52:55', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (60, 6, 10, 1, 53, 80, 60, '2022-05-18 18:38:13', '2022-05-18 18:52:56', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (61, 4, 11, 1, 60, 80, 60, '2022-05-18 18:38:39', '2022-05-18 18:52:56', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (62, 4, 11, 1, 60, 80, 60, '2022-05-18 18:38:50', '2022-05-18 18:52:57', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (63, 4, 11, 1, 53, 80, 60, '2022-05-18 18:39:47', '2022-05-18 18:52:57', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (64, 4, 12, 1, 60, 50, 40, '2022-05-18 18:40:05', '2022-05-18 18:52:58', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (65, 5, 12, 1, 60, 50, 40, '2022-05-18 18:40:25', '2022-05-18 18:52:59', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (66, 4, 12, 1, 53, 50, 40, '2022-05-18 18:40:38', '2022-05-18 18:52:59', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (67, 3, 13, 1, 60, 80, 60, '2022-05-18 18:41:09', '2022-05-18 18:53:00', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (68, 10, 13, 1, 60, 80, 60, '2022-05-18 18:41:29', '2022-05-18 18:53:01', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (69, 12, 13, 1, 53, 80, 60, '2022-05-18 18:41:43', '2022-05-18 18:53:01', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (70, 12, 14, 1, 60, 999, 80, '2022-05-18 18:42:44', '2022-05-18 18:53:02', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (71, 10, 14, 1, 60, 999, 80, '2022-05-18 18:42:56', '2022-05-18 18:53:02', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (72, 6, 14, 1, 53, 999, 80, '2022-05-18 18:43:28', '2022-05-18 18:53:03', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (73, 10, 27, 0, 50, 80, 60, '2022-05-18 18:56:25', '2022-05-18 19:01:05', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (74, 13, 26, 0, 50, 80, 60, '2022-05-18 18:58:08', '2022-05-18 19:01:06', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (75, 6, 25, 0, 50, 80, 60, '2022-05-18 18:59:14', '2022-05-18 19:01:07', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (76, 12, 24, 0, 50, 80, 60, '2022-05-18 18:59:53', '2022-05-18 19:01:07', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (77, 4, 23, 0, 50, 50, 40, '2022-05-18 19:00:11', '2022-05-18 19:01:08', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (78, 12, 30, 1, 50, 80, 60, '2022-05-18 19:03:27', '2022-05-18 19:11:17', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (79, 12, 30, 1, 55, 80, 60, '2022-05-18 19:03:39', '2022-05-18 19:11:18', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (80, 4, 29, 1, 50, 80, 60, '2022-05-18 19:04:07', '2022-05-18 19:11:18', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (81, 5, 29, 1, 55, 80, 60, '2022-05-18 19:04:40', '2022-05-18 19:11:19', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (82, 3, 28, 1, 50, 80, 60, '2022-05-18 19:05:56', '2022-05-18 19:11:19', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (83, 6, 28, 1, 55, 80, 60, '2022-05-18 19:06:12', '2022-05-18 19:11:20', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (84, 13, 41, 0, 45, 80, 60, '2022-05-18 19:24:02', '2022-05-18 19:24:24', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (85, 13, 41, 0, 45, 80, 60, '2022-05-18 19:24:17', '2022-05-18 19:24:25', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (86, 4, 16, 0, 32, 999, 30, '2022-05-18 19:40:08', '2022-05-18 19:43:31', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (87, 4, 22, 0, 50, 80, 60, '2022-05-18 19:42:21', '2022-05-18 19:43:36', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (88, 3, 16, 0, 34, 999, 30, '2022-05-18 19:42:35', '2022-05-18 19:43:26', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (89, 10, 16, 0, 34, 999, 30, '2022-05-18 19:42:55', '2022-05-18 19:43:40', 1);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (90, 6, 16, 0, 32, 999, 30, '2022-05-18 19:46:51', NULL, 0);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (91, 4, 16, 0, 30, 999, 30, '2022-05-18 19:47:04', NULL, 0);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (92, 10, 16, 0, 32, 999, 30, '2022-05-18 19:47:15', NULL, 0);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (93, 3, 16, 0, 31, 999, 30, '2022-05-18 19:47:21', NULL, 0);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (94, 12, 22, 0, 50, 80, 60, '2022-05-18 19:47:58', NULL, 0);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (95, 4, 32, 1, 55, 80, 60, '2022-05-18 19:48:34', NULL, 0);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (96, 5, 40, 0, 45, 80, 60, '2022-05-18 19:49:06', NULL, 0);
INSERT INTO `task` (`id`, `teacher_id`, `plan_id`, `merge`, `actual_num`, `max_num`, `common_num`, `create_time`, `update_time`, `deleted`) VALUES (97, 10, 40, 0, 45, 80, 60, '2022-05-18 19:49:19', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for task_final
-- ----------------------------
DROP TABLE IF EXISTS `task_final`;
CREATE TABLE `task_final` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '定稿教学任务id',
  `experimental` float(11,2) DEFAULT NULL COMMENT '实验学时',
  `theoretical` float(11,2) DEFAULT NULL COMMENT '理论学时',
  `credit` float(11,2) DEFAULT NULL COMMENT '学分',
  `teacher` varchar(32) DEFAULT NULL COMMENT '授课教师',
  `merge` int DEFAULT NULL COMMENT '是否合班：0 否 1 是',
  `actual_num` int DEFAULT NULL COMMENT '教学班实际人数',
  `max_num` int DEFAULT NULL COMMENT '教学班最大人数',
  `common_num` int DEFAULT NULL COMMENT '教学班标准人数',
  `major` varchar(32) DEFAULT NULL COMMENT '专业',
  `course_name` varchar(32) DEFAULT NULL COMMENT '课程名称',
  `course_type` varchar(32) DEFAULT NULL COMMENT '课程类别',
  `grade` int DEFAULT NULL COMMENT '年级',
  `semester` varchar(32) DEFAULT NULL COMMENT '学期：XXXX-XXXX-X',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of task_final
-- ----------------------------
BEGIN;
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (35, 0.00, 56.00, 3.50, '何全庆', 1, 60, 80, 60, '软件工程', '程序设计基础', '学科基础、专业课（不含艺术学院）', 2018, '2018-2019-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (36, 0.00, 56.00, 3.50, '何全庆', 1, 60, 80, 60, '软件工程', '程序设计基础', '学科基础、专业课（不含艺术学院）', 2018, '2018-2019-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (37, 0.00, 56.00, 3.50, '何全庆', 1, 53, 80, 60, '软件工程', '程序设计基础', '学科基础、专业课（不含艺术学院）', 2018, '2018-2019-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (38, 0.00, 56.00, 3.50, '张会', 1, 60, 80, 60, '软件工程', '面向对象程序设计', '学科基础、专业课（不含艺术学院）', 2018, '2018-2019-2');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (39, 0.00, 56.00, 3.50, '张会', 1, 60, 80, 60, '软件工程', '面向对象程序设计', '学科基础、专业课（不含艺术学院）', 2018, '2018-2019-2');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (40, 0.00, 56.00, 3.50, '张会', 1, 53, 80, 60, '软件工程', '面向对象程序设计', '学科基础、专业课（不含艺术学院）', 2018, '2018-2019-2');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (41, 0.00, 32.00, 2.00, '陈斌', 1, 60, 80, 60, '软件工程', '面向对象需求分析与建模', '学科基础、专业课（不含艺术学院）', 2018, '2019-2020-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (42, 0.00, 32.00, 2.00, '陈斌', 1, 60, 80, 60, '软件工程', '面向对象需求分析与建模', '学科基础、专业课（不含艺术学院）', 2018, '2019-2020-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (43, 0.00, 32.00, 2.00, '周朝萱', 1, 53, 80, 60, '软件工程', '面向对象需求分析与建模', '学科基础、专业课（不含艺术学院）', 2018, '2019-2020-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (44, 0.00, 40.00, 2.50, '兰全祥', 1, 60, 80, 60, '软件工程', 'Web前端开发技术', '学科基础、专业课（不含艺术学院）', 2018, '2019-2020-2');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (45, 0.00, 40.00, 2.50, '兰全祥', 1, 60, 80, 60, '软件工程', 'Web前端开发技术', '学科基础、专业课（不含艺术学院）', 2018, '2019-2020-2');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (46, 0.00, 40.00, 2.50, '兰全祥', 1, 53, 80, 60, '软件工程', 'Web前端开发技术', '学科基础、专业课（不含艺术学院）', 2018, '2019-2020-2');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (47, 56.00, 0.00, 3.50, '兰全祥', 1, 60, 50, 40, '软件工程', 'JAVA WEB应用开发实训', '专业实验课', 2018, '2020-2021-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (48, 56.00, 0.00, 3.50, '张会', 1, 60, 50, 40, '软件工程', 'JAVA WEB应用开发实训', '专业实验课', 2018, '2020-2021-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (49, 56.00, 0.00, 3.50, '兰全祥', 1, 53, 50, 40, '软件工程', 'JAVA WEB应用开发实训', '专业实验课', 2018, '2020-2021-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (50, 0.00, 32.00, 2.00, '张靖', 1, 60, 80, 60, '软件工程', '软件工程及项目管理', '学科基础、专业课（不含艺术学院）', 2018, '2020-2021-2');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (51, 0.00, 32.00, 2.00, '陈斌', 1, 60, 80, 60, '软件工程', '软件工程及项目管理', '学科基础、专业课（不含艺术学院）', 2018, '2020-2021-2');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (52, 0.00, 32.00, 2.00, '吴建兵', 1, 53, 80, 60, '软件工程', '软件工程及项目管理', '学科基础、专业课（不含艺术学院）', 2018, '2020-2021-2');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (53, 0.00, 0.00, 2.00, '吴建兵', 1, 60, 999, 80, '软件工程', '毕业实习', '非医学专业毕业实习', 2018, '2021-2022-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (54, 0.00, 0.00, 2.00, '陈斌', 1, 60, 999, 80, '软件工程', '毕业实习', '非医学专业毕业实习', 2018, '2021-2022-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (55, 0.00, 0.00, 2.00, '周朝萱', 1, 53, 999, 80, '软件工程', '毕业实习', '非医学专业毕业实习', 2018, '2021-2022-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (56, 0.00, 56.00, 3.50, '陈斌', 0, 50, 80, 60, '软件工程', '程序设计基础', '学科基础、专业课（不含艺术学院）', 2019, '2019-2020-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (57, 0.00, 56.00, 3.50, '何全庆', 0, 50, 80, 60, '软件工程', '面向对象程序设计', '学科基础、专业课（不含艺术学院）', 2019, '2019-2020-2');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (58, 0.00, 32.00, 2.00, '周朝萱', 0, 50, 80, 60, '软件工程', '面向对象需求分析与建模', '学科基础、专业课（不含艺术学院）', 2019, '2020-2021-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (59, 0.00, 40.00, 2.50, '吴建兵', 0, 50, 80, 60, '软件工程', 'Web前端开发技术', '学科基础、专业课（不含艺术学院）', 2019, '2020-2021-2');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (60, 56.00, 0.00, 3.50, '兰全祥', 0, 50, 50, 40, '软件工程', 'JAVA WEB应用开发实训', '专业实验课', 2019, '2021-2022-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (61, 0.00, 56.00, 3.50, '吴建兵', 1, 50, 80, 60, '软件工程', '程序设计基础', '学科基础、专业课（不含艺术学院）', 2020, '2020-2021-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (62, 0.00, 56.00, 3.50, '吴建兵', 1, 55, 80, 60, '软件工程', '程序设计基础', '学科基础、专业课（不含艺术学院）', 2020, '2020-2021-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (63, 0.00, 56.00, 3.50, '兰全祥', 1, 50, 80, 60, '软件工程', '面向对象程序设计', '学科基础、专业课（不含艺术学院）', 2020, '2020-2021-2');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (64, 0.00, 56.00, 3.50, '张会', 1, 55, 80, 60, '软件工程', '面向对象程序设计', '学科基础、专业课（不含艺术学院）', 2020, '2020-2021-2');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (65, 0.00, 32.00, 2.00, '张靖', 1, 50, 80, 60, '软件工程', '面向对象需求分析与建模', '学科基础、专业课（不含艺术学院）', 2020, '2021-2022-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (66, 0.00, 32.00, 2.00, '周朝萱', 1, 55, 80, 60, '软件工程', '面向对象需求分析与建模', '学科基础、专业课（不含艺术学院）', 2020, '2021-2022-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (67, 0.00, 56.00, 3.50, '何全庆', 0, 45, 80, 60, '软件工程', '程序设计基础', '学科基础、专业课（不含艺术学院）', 2021, '2021-2022-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (68, 0.00, 56.00, 3.50, '何全庆', 0, 45, 80, 60, '软件工程', '程序设计基础', '学科基础、专业课（不含艺术学院）', 2021, '2021-2022-1');
INSERT INTO `task_final` (`id`, `experimental`, `theoretical`, `credit`, `teacher`, `merge`, `actual_num`, `max_num`, `common_num`, `major`, `course_name`, `course_type`, `grade`, `semester`) VALUES (69, 0.00, 56.00, 3.50, '何全庆', 0, 45, 80, 60, '软件工程', '程序设计基础', '学科基础、专业课（不含艺术学院）', 2021, '2021-2022-1');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `account` varchar(16) NOT NULL COMMENT '账号',
  `password` varchar(64) NOT NULL COMMENT '密码',
  `username` varchar(64) NOT NULL COMMENT '用户名',
  `email` varchar(64) DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(11) DEFAULT NULL COMMENT '电话号码',
  `role_id` int NOT NULL COMMENT '外键：角色id',
  `group_id` int NOT NULL COMMENT '组id',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除：1 为以删除',
  PRIMARY KEY (`id`),
  KEY `role_id` (`role_id`),
  KEY `group_id` (`group_id`),
  CONSTRAINT `user_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`),
  CONSTRAINT `user_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `account`, `password`, `username`, `email`, `phone`, `role_id`, `group_id`, `create_time`, `update_time`, `deleted`) VALUES (1, 'admin', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '彭治皓', NULL, NULL, 1, 1, '2022-04-01 00:45:27', '2022-04-11 13:09:59', 0);
INSERT INTO `user` (`id`, `account`, `password`, `username`, `email`, `phone`, `role_id`, `group_id`, `create_time`, `update_time`, `deleted`) VALUES (2, 'test1', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '测试账户1', NULL, NULL, 1, 3, '2022-04-11 15:09:45', '2022-04-20 15:00:21', 1);
INSERT INTO `user` (`id`, `account`, `password`, `username`, `email`, `phone`, `role_id`, `group_id`, `create_time`, `update_time`, `deleted`) VALUES (3, 'sj001', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '张靖', 'pzh@pzhuweb.cn', '18234228266', 2, 3, '2022-04-20 14:56:57', '2022-05-17 16:52:54', 0);
INSERT INTO `user` (`id`, `account`, `password`, `username`, `email`, `phone`, `role_id`, `group_id`, `create_time`, `update_time`, `deleted`) VALUES (4, 'sj002', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '兰全祥', NULL, NULL, 3, 3, '2022-04-20 15:00:15', '2022-05-17 17:30:52', 0);
INSERT INTO `user` (`id`, `account`, `password`, `username`, `email`, `phone`, `role_id`, `group_id`, `create_time`, `update_time`, `deleted`) VALUES (5, 'sj003', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '张会', NULL, NULL, 4, 3, '2022-04-20 15:04:17', '2022-05-17 17:20:24', 0);
INSERT INTO `user` (`id`, `account`, `password`, `username`, `email`, `phone`, `role_id`, `group_id`, `create_time`, `update_time`, `deleted`) VALUES (6, 'sj004', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '周朝萱', NULL, NULL, 4, 3, '2022-04-20 15:04:54', '2022-05-17 17:20:41', 0);
INSERT INTO `user` (`id`, `account`, `password`, `username`, `email`, `phone`, `role_id`, `group_id`, `create_time`, `update_time`, `deleted`) VALUES (7, 'fx001', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '安小其', NULL, NULL, 3, 7, '2022-05-14 15:47:01', NULL, 0);
INSERT INTO `user` (`id`, `account`, `password`, `username`, `email`, `phone`, `role_id`, `group_id`, `create_time`, `update_time`, `deleted`) VALUES (8, '0001', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '刘立新', NULL, NULL, 7, 8, '2022-05-15 10:03:58', '2022-05-17 17:28:01', 0);
INSERT INTO `user` (`id`, `account`, `password`, `username`, `email`, `phone`, `role_id`, `group_id`, `create_time`, `update_time`, `deleted`) VALUES (9, 'sj011', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '刘冬兵', NULL, NULL, 3, 8, '2022-05-17 17:29:01', NULL, 0);
INSERT INTO `user` (`id`, `account`, `password`, `username`, `email`, `phone`, `role_id`, `group_id`, `create_time`, `update_time`, `deleted`) VALUES (10, 'sj005', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '陈斌', NULL, NULL, 4, 3, '2022-05-17 17:32:38', NULL, 0);
INSERT INTO `user` (`id`, `account`, `password`, `username`, `email`, `phone`, `role_id`, `group_id`, `create_time`, `update_time`, `deleted`) VALUES (11, 'sj012', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '刘涛', NULL, NULL, 4, 8, '2022-05-17 23:52:27', NULL, 0);
INSERT INTO `user` (`id`, `account`, `password`, `username`, `email`, `phone`, `role_id`, `group_id`, `create_time`, `update_time`, `deleted`) VALUES (12, 'sj006', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '吴建兵', NULL, NULL, 4, 3, '2022-05-18 16:39:23', NULL, 0);
INSERT INTO `user` (`id`, `account`, `password`, `username`, `email`, `phone`, `role_id`, `group_id`, `create_time`, `update_time`, `deleted`) VALUES (13, 'sj007', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', '何全庆', NULL, NULL, 4, 3, '2022-05-18 16:40:42', NULL, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
